www.gusucode.com > wxApp PHP版微信小程序CMS系统 v1.0PHP源码程序 > wxApp PHP版微信小程序CMS系统 v1.0/wxAppCMS_v1.0.0/wxAppCMS_v1.0.0/app/keywords/keywords.admincp.php

    <?php
/**
* iCMS - i Content Management System
* Copyright (c) 2007-2017 iCMSdev.com. All rights reserved.
*
* @author icmsdev <master@icmsdev.com>
* @site https://www.icmsdev.com
* @licence https://www.icmsdev.com/LICENSE.html
*/
class keywordsAdmincp{
    public function __construct() {
        $this->appid = iCMS_APP_KEYWORDS;
    	$this->id	= (int)$_GET['id'];
    }
    public function do_config(){
        configAdmincp::app($this->appid);
    }
    public function do_save_config(){
        configAdmincp::save($this->appid);
    }
    public function do_add(){
        if($this->id) {
            $rs = iDB::row("SELECT * FROM `#iCMS@__keywords` WHERE `id`='$this->id' LIMIT 1;",ARRAY_A);
        }else{
            $rs['keyword'] = $_GET['keyword'];
            $rs['replace'] = $_GET['replace'];
        }
        $_GET['url'] && $rs['replace'] =  self::get_replace($rs['keyword'],$_GET['url']);

        include admincp::view("keywords.add");
    }
    public function do_save(){
        $id      = (int)$_POST['id'];
        $keyword = iSecurity::escapeStr($_POST['keyword']);
        $replace = iSecurity::escapeStr($_POST['replace']);

        $keyword OR iUI::alert('关键词不能为空!');
        $replace OR iUI::alert('替换词不能为空!');
        $fields = array('keyword', 'replace');
        $data   = compact($fields);

        if(empty($id)) {
            iDB::value("SELECT `id` FROM `#iCMS@__keywords` where `keyword` ='$keyword'") && iUI::alert('该关键词已经存在!');
            iDB::insert('keywords',$data);
            $msg="关键词添加完成!";
        }else {
            iDB::value("SELECT `id` FROM `#iCMS@__keywords` where `keyword` ='$keyword' AND `id` !='$id'") && iUI::alert('该关键词已经存在!');
            iDB::update('keywords', $data, array('id'=>$id));
            $msg="关键词编辑完成!";
        }
        $this->cache();
        iUI::success($msg,'url:'.APP_URI);
    }
    public static function insert($name,$url=null){
        if(is_array($name) && empty($url)){
            $data = $name;
        }else{
            $data = array();
            $data['keyword'] = $name;
            $data['replace'] = self::get_replace($name,$url);
            array_map('addslashes', $data);
        }
        if($data){
            if(!iDB::value("SELECT `id` FROM `#iCMS@__keywords` where `keyword` ='".$data['keyword']."'")){
                return iDB::insert('keywords',$data);
            }
        }
        return false;
    }
    public function do_iCMS(){
        if($_GET['keywords']) {
			$sql=" WHERE `keyword` REGEXP '{$_GET['keywords']}'";
        }
        list($orderby,$orderby_option) = get_orderby();

        $maxperpage = $_GET['perpage']>0?(int)$_GET['perpage']:20;
		$total		= iCMS::page_total_cache("SELECT count(*) FROM `#iCMS@__keywords` {$sql}","G");
        iUI::pagenav($total,$maxperpage,"个关键词");
        $rs     = iDB::all("SELECT * FROM `#iCMS@__keywords` {$sql} order by {$orderby} LIMIT ".iUI::$offset." , {$maxperpage}");
        $_count = count($rs);
    	include admincp::view("keywords.manage");
    }
    public function do_del($id = null,$dialog=true){
    	$id===null && $id=$this->id;
		$id OR iUI::alert('请选择要删除的关键词!');
		iDB::query("DELETE FROM `#iCMS@__keywords` WHERE `id` = '$id'");
		$this->cache();
		$dialog && iUI::success('关键词已经删除','js:parent.$("#id'.$id.'").remove();');
    }
    public function do_batch(){
        $idArray = (array)$_POST['id'];
        $idArray OR iUI::alert("请选择要操作的关键词");
        $ids     = implode(',',$idArray);
        $batch   = $_POST['batch'];
    	switch($batch){
    		case 'dels':
				iUI::$break	= false;
	    		foreach($idArray AS $id){
	    			$this->do_del($id,false);
	    		}
	    		iUI::$break	= true;
				iUI::success('关键词全部删除完成!','js:1');
    		break;
		}
	}
    public function do_cache($dialog=true){
        $this->cache();
        $dialog && iUI::success('更新完成');
    }
    public static function cache(){
        $rs    = iDB::all("SELECT * FROM `#iCMS@__keywords` ORDER BY CHAR_LENGTH(`keyword`) DESC");
        $array = array();
        foreach((array)$rs AS $i=>$val) {
            $array[] = array($val['keyword'],htmlspecialchars_decode($val['replace']));
        }
        iCache::set(keywordsApp::CACHE_KEY,$array,0);
    }
    public static function get_replace($name,$url){
        return htmlspecialchars('<a href="'.$url.'" target="_blank" class="keywords">'.$name.'</a>');
    }
    public static function _count(){
        return iDB::value("SELECT count(*) FROM `#iCMS@__keywords`");
    }
}